# coding:utf-8

import pandas as pd

raw_data = pd.read_excel("去重数据示例.xlsx")

print(raw_data)
print("-----------")
print(raw_data.duplicated(subset=["姓名"]))
print("-----------")
# first,last,False
new_data = raw_data.drop_duplicates(subset=["姓名"], keep='first')
print(new_data)
